package com.witte.dao;

import java.util.List;

import com.witte.entity.Offer;
import org.apache.ibatis.annotations.Mapper;

import com.witte.entity.CusNOrdProN;
import com.witte.entity.Orders;
import com.witte.entity.Statitic;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface OrdersMapper {
    int deleteByPrimaryKey(String orderno);

    int insert(Orders record);

    int insertSelective(Orders record);

    Orders selectByPrimaryKey(String orderno);

    int updateByPrimaryKeySelective(Orders record);

    int updateByPrimaryKey(Orders record);
    
    List<Orders> selectAllOrders();
    
    int selectSumMoney();
    
    List<CusNOrdProN> selectCusAllMoney();
    
    List<Orders> selectByCId(int customerId);

    List<Orders> selectForPage(@Param("beginPage") Integer beginPage, @Param("pageSize") Integer pageSize);

    int getAllCount();
    
    List<Integer> selectNoByOverTime();
}